SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 35828 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 35828 [ RunTime:0.001791s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (252601,754083,897166,260594,367782,177923,853924,169524,557837,369841,1035111,252657,555297,980551,796269,317298,1017461,1022781,211880,1034386,743887,507332,834560,573963,125898,822634,187113,694646,576277,818426,270759,942619,721496,63519,611323,509018,356826,631329,205244,835929,387369,612124,455615,900170,136594,266233,774351,1001220,801895,1001746,420967,264429,779348,502604,512470,703971,508571,1007492,637597,418156) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 35828 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 35828 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]