SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 312005 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 312005 [ RunTime:0.001602s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (719124,829389,1005675,608660,326165,356854,752908,619914,886418,603708,48624,58139,44610,264312,194922,699689,737303,905744,440888,1001115,366122,532111,246571,158788,211975,8351,348038,853972,406964,438028,541238,11123,25941,697859,432693,189595,259691,530346,926219,34829,835043,721898,653306,621430,160066,858988,279467,393739,880351,215418,814959,582847,150886,287314,187162,779469,130157,1010989,676637,143504) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004923s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 312005 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 312005 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]