SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 3500 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 3500 [ RunTime:0.005665s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (518571,505160,754838,558365,77244,762273,990469,639232,763766,328270,223745,25005,410341,449641,912482,520547,91642,119770,935818,574132,638215,340361,453613,271547,404282,821010,870263,1000076,381203,456614,239538,392266,837118,715364,480991,87949,475801,768919,632392,507166,1028473,451051,47715,576534,78538,856940,150187,396078,220588,417284,968922,53777,409724,9236,813163,710446,520645,238416,893290,29409) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 3500 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 3500 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]