SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538074 LIMIT 1 [ RunTime:0.001019s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538074 [ RunTime:0.001720s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (44106,665371,53272,352153,38050,977400,379336,380740,820300,539003,805170,884837,417012,263133,104295,845049,942026,989276,134400,294091,672183,993299,449779,233611,398930,973049,506707,51110,365978,555742,730390,93325,276256,974295,55568,510638,813858,361075,388693,744748,890043,191296,904762,663609,81019,608780,979796,903458,648563,270062,253664,499827,95580,937639,637523,633616,268754,257663,154434,773151) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538074 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538074 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]