SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416604 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416604 [ RunTime:0.002874s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (849813,608724,501003,126038,830211,974224,70782,764435,366338,706642,577413,39375,113387,842635,576310,366318,847762,386430,809013,891769,496026,945836,134876,820892,42465,414421,540337,208705,998598,873422,861036,862153,1025810,963368,173170,251394,788653,622996,320665,949024,876869,383118,953404,797270,1027111,395948,1040036,794764,468768,189434,1032199,214221,608734,273935,228336,111829,408466,80118,487543,864916) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001708s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416604 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000606s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416604 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]