SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020830 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020830 [ RunTime:0.001869s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (360906,661102,242610,723353,718789,379775,168226,978897,911670,484673,269557,243999,312577,108320,950094,286041,820279,656767,448094,86393,776735,494841,761464,298025,531955,257539,187204,881530,362628,715559,701419,189566,970588,598861,790259,74707,61211,708420,415171,524993,843103,140686,887638,90457,650496,793556,192734,360807,533187,163790,63496,659232,208824,611108,639234,23463,110368,234453,508732,986208) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020830 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000614s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020830 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]