SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003692s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 113513 LIMIT 1 [ RunTime:0.002032s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 113513 [ RunTime:0.003791s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (602773,123363,205402,1028674,99827,9435,84777,508611,498968,884224,412245,872342,436008,204946,267320,570603,720030,840471,325066,833369,878328,365127,154437,549927,994919,783069,856311,592134,773012,619437,636580,113655,94547,302168,703270,903891,473062,454480,304218,663737,937750,80010,404057,916274,296789,495527,125120,226043,498221,783136,1034160,832771,781743,16026,345986,73707,1045163,513339,266311,862610) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 113513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000559s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 113513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]