SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564211 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564211 [ RunTime:0.003259s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (569505,1041370,714238,1005612,358753,924707,246285,494377,555949,539795,500116,201334,194697,178065,909133,682963,780424,804419,775191,310119,968281,625753,813327,609526,656319,14209,72953,1019654,212057,1009773,25100,332300,193028,317468,446924,139347,133039,661621,24514,326518,340326,666874,428678,740001,854615,455422,601011,901193,564017,562503,387223,566513,160445,800906,117581,1012635,299659,287051,271927,623659) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]