SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002470s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102993 LIMIT 1 [ RunTime:0.000636s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102993 [ RunTime:0.003368s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (351111,142819,80276,236504,778229,580411,611583,94973,214651,102456,571542,16011,207167,554921,812651,321105,959116,632887,795041,875341,653824,707201,895365,861397,11758,1028153,265727,754776,691791,289307,438714,977037,913772,902562,685678,755334,204789,487748,147167,328679,186634,57233,886922,1006282,570976,824510,589111,508950,186721,910831,533916,567986,119890,878565,945822,758543,358974,431015,901776,770276) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102993 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102993 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000682s ]