SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419856 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419856 [ RunTime:0.002765s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509616,799411,545684,854455,866572,369481,110198,1028284,794973,87172,501157,977133,396249,561763,687223,162367,85512,1027354,292247,875700,135702,279462,122694,78865,339724,561375,273666,860956,197518,681153,362671,441968,64782,61721,820068,935039,541350,555366,272502,572926,11712,739188,331401,380078,238236,81881,815456,331018,357740,416077,122222,24773,343924,764163,1029251,324808,804032,524389,673710,786205) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419856 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419856 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]