SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429823 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429823 [ RunTime:0.001757s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (533816,729763,489556,910745,124586,135420,9837,769622,398689,5588,150430,340913,673201,493784,217520,770237,90194,61702,167682,695170,362540,817503,520886,637648,424216,342246,211988,675865,649513,360145,574574,604314,996962,137789,640223,409546,617322,378195,23258,653259,114206,1026190,347085,129322,771821,625847,389696,848043,521067,181070,716675,800745,832940,235659,533409,973130,300610,138614,942822,220927) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001498s ]