SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539988 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539988 [ RunTime:0.001450s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (543921,975863,910322,1001083,565053,528169,42458,176601,859552,957951,922499,342336,550713,12355,981579,336788,52980,620526,390154,447517,389552,373675,907852,136200,927553,97213,947155,573013,887921,600850,589197,197000,232713,113467,227443,960840,797642,7004,544790,748726,165715,889632,1022363,924690,790323,819065,383492,230562,587157,695708,941223,359693,62724,588949,676187,383650,840583,694776,828596,291288) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539988 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539988 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]