SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003944 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003944 [ RunTime:0.001442s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1017238,745946,624102,622305,902365,54222,276696,425145,20701,438774,619523,335620,208834,203497,386388,201595,169684,147454,685236,47033,705521,293095,577628,45316,46170,30134,560023,132432,624948,400314,952959,390292,808835,460559,559685,792026,379825,217876,874316,808021,751194,723127,970200,232899,135185,1028817,279266,638737,201472,566172,937964,306371,248459,402047,66088,644502,254554,885300,510547,302074) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003944 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000712s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003944 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]