SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 245376 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 245376 [ RunTime:0.001538s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (168782,492239,1033141,474826,899287,275104,332453,223639,494576,897720,152821,378919,318894,516080,663699,414907,210726,251839,760587,11570,803113,536361,782802,605153,983498,728731,334614,46916,989555,493287,855678,645638,438319,1043539,800848,560172,601488,884281,544272,725316,561658,686754,791318,133672,402539,896,346761,538349,858141,62195,60497,358197,476798,1011361,356128,454568,822437,444706,886068,708713) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 245376 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 245376 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001137s ]