SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514188 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514188 [ RunTime:0.001807s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (291577,199579,622972,368337,482372,182840,355817,330412,601248,93768,795708,320784,567972,791680,901503,389851,874110,390154,563131,906710,584449,638791,133278,646613,647641,951169,56071,583660,56085,756534,104273,779067,955927,194875,700425,773595,96684,820183,554691,115322,832271,58568,470125,1036779,601522,493621,463086,849230,601901,225581,266845,657674,229970,840122,748470,595139,349793,360809,600181,676915) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514188 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514188 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]