SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026880 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026880 [ RunTime:0.002033s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (474731,590027,624342,225584,678315,627205,66124,704844,420506,677635,232591,407003,987829,516764,917846,335161,150814,598469,871190,802108,475271,445472,47132,385074,808909,84198,385312,941164,39808,983716,101368,92700,692848,597508,9330,549998,192110,321188,293424,533709,921286,383110,795145,540674,101153,706685,938502,479245,924593,528334,743398,660559,245968,283794,907952,397076,985776,373824,416396,744098) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026880 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026880 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]