SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001359s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4423 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4423 [ RunTime:0.001781s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (724747,253953,823146,49159,592299,141201,621179,36013,472521,689260,681340,476221,1998,137855,111898,129789,871050,57351,652217,293684,242426,909191,266070,500165,259506,1036647,512631,971911,459761,37561,664769,314507,452565,1027129,91795,133488,583059,488469,115173,858880,526151,890437,1036290,51270,433631,328015,621669,724478,657027,465870,974957,731188,159823,94458,43021,974076,909098,1001861,753559,220357) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]