SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000927s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500610 LIMIT 1 [ RunTime:0.000682s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500610 [ RunTime:0.002428s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (152628,728775,211700,282095,690985,741435,496899,582452,103700,14063,237040,359257,196519,954158,400199,667950,474411,757166,470458,133472,444562,552836,707086,286897,955412,1031211,12407,681722,374805,221600,659432,89784,957508,875641,583922,472277,638047,758591,328018,455435,155739,938961,497467,791100,781717,132572,299845,330327,75328,75872,109737,1015636,255798,911369,200707,253003,497985,183307,772663,383329) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002828s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000525s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]