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` = 548328 LIMIT 1 [ RunTime:0.000572s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548328 [ RunTime:0.001624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (394737,637212,537572,205463,272842,932421,149213,914009,201657,42901,277531,1002949,641988,979029,57204,439190,497118,569863,1029215,794216,62623,117627,907496,105528,712075,141357,416087,143073,742469,290727,457753,129376,544075,118302,614360,233524,666674,141643,670917,601399,152319,470431,513818,881641,853356,724658,1033277,949248,342554,263706,400452,603445,828493,730156,523201,486976,264584,434332,256927,478569) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]