SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029467 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029467 [ RunTime:0.001923s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (793100,819161,659577,567161,1011384,1008268,276479,798,995758,907466,953115,592469,200547,68020,390600,309339,99338,699094,897647,554112,520538,89674,871377,433541,408517,1012847,14151,258541,543233,1025949,146547,781994,146041,1021543,584579,1029863,94870,925231,570729,917408,627842,8939,840993,266601,377291,769971,633756,1042843,803524,44163,501484,648019,897768,569305,638831,656414,507860,754089,346220,1023881) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029467 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029467 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000680s ]