SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401511 LIMIT 1 [ RunTime:0.001558s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401511 [ RunTime:0.001889s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1029172,229819,159085,250061,46257,978920,700335,634362,44667,802327,139407,705479,1036067,424528,970738,15832,2089,530889,138087,109665,937343,31948,906208,102707,754528,112233,656954,862212,612600,495235,566085,322933,317865,30529,1039601,847896,696851,378286,945356,548413,723286,622838,889676,825642,927907,697074,593757,500467,337322,98641,806174,950984,740351,613606,378960,685249,570873,774277,499085,436415) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001534s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000688s ]