SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391949 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391949 [ RunTime:0.001731s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1042787,1044744,1007923,615053,554148,855530,358405,399462,523457,36630,997751,23614,655161,319291,112912,886897,919530,509365,60715,729582,686318,873144,732941,813137,280473,119291,326159,856317,944289,126850,101200,663679,869827,2516,874802,205996,394236,1010983,671230,883160,829761,74641,821832,984711,486692,935009,112663,337235,498909,891764,52600,476137,52499,451425,412671,211901,952896,681694,57269,634395) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391949 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391949 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000697s ]