SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001388s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014071 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014071 [ RunTime:0.003336s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (193908,436335,633580,453815,710930,518845,29238,279485,810488,208050,395507,250004,294613,892812,251332,999797,7271,233620,909584,1038745,906807,764333,339331,181649,865659,206578,893173,989181,1017796,916426,983215,85386,180279,23166,166292,745435,835101,569559,566952,86092,807761,121125,863985,984302,13742,326739,826816,934964,705390,193254,768572,566580,476256,92109,560511,29338,236486,233683,465984,668124) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000540s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]