SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508872 LIMIT 1 [ RunTime:0.000858s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508872 [ RunTime:0.002100s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (778449,975636,898208,417172,768576,551454,225140,674440,779398,914389,167376,216465,551080,1015061,358937,1016856,483103,505737,714363,563308,117565,309840,420083,501698,611995,914128,99648,255347,1003527,314175,114340,256429,663116,569434,387492,97262,560370,997474,604678,913302,627621,554160,944027,677962,113116,114225,995794,952513,720056,646681,960101,763421,356400,505696,748042,275132,835363,140182,38325,761909) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508872 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508872 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]