SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 347418 LIMIT 1 [ RunTime:0.004151s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 347418 [ RunTime:0.007897s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (141903,49450,10386,690782,574664,692312,328756,539172,777585,721886,597956,910967,724026,929513,195521,488871,904780,740332,120714,498766,261990,576443,967275,432088,850414,154992,91369,471527,537236,90528,242102,210176,619986,54248,824363,1019656,947824,7060,508654,73229,994018,296659,663417,572715,891451,849759,880754,437051,361200,439463,748859,309161,503138,379607,709510,169468,216267,632790,681230,680624) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005916s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 347418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 347418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.011415s ]