SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408860 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408860 [ RunTime:0.001547s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (404077,1003942,984492,852471,748683,968407,6788,84004,84483,874199,263063,580785,26702,808881,551337,989675,878121,321622,869552,292806,518360,391684,578932,693085,313263,337854,393208,1034185,182203,36296,256835,615002,516604,180908,59353,804037,371395,852644,267079,20667,131877,9987,922063,710083,644167,77338,395262,411987,873236,82122,621222,80605,75217,217466,647823,1038780,553229,121704,375145,225262) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001576s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]