SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001687s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515240 LIMIT 1 [ RunTime:0.000446s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515240 [ RunTime:0.001674s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (197128,531769,561999,1019740,1040441,53757,873784,1007990,675431,433592,494629,648247,875201,340701,741035,948089,867507,470080,134361,791778,1047085,933859,586687,216867,433865,909663,442699,824931,714590,336356,172384,526430,446966,486345,905572,350632,337775,292560,595712,68124,325538,451641,170258,1018632,661029,780838,651135,650052,1027544,888729,505406,883150,366802,718873,850451,736063,553783,231905,778595,784324) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515240 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515240 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]