SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410475 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410475 [ RunTime:0.001797s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (909014,249225,501161,727490,108520,150429,33032,413873,102542,1009964,1020404,950472,138401,495022,854437,145945,575333,514320,837097,867455,342405,366464,60080,89021,491458,219983,86840,668490,335680,129129,426017,209983,608545,223510,786948,384280,285678,123065,238318,320724,428828,461302,115762,532071,985,365464,865171,219953,720428,595995,814962,960476,639557,821642,1041680,871364,7268,627821,175936,824782) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410475 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410475 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]