SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38044 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38044 [ RunTime:0.001903s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200828,324134,331442,952621,658560,368755,364780,366546,631740,268658,76935,589139,674952,805411,884739,193179,783834,781736,310184,209752,581660,875739,3423,957592,47459,529675,455594,653565,970143,964546,292924,215987,587565,487502,10029,986137,604373,199147,912305,170372,136021,122836,500870,582856,902484,928504,457434,486083,898682,569139,305068,116459,220452,59657,956171,705030,886915,441418,127898,355402) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38044 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38044 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002716s ]