SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473100 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473100 [ RunTime:0.001528s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (909428,70636,208318,51160,730928,692911,507784,324232,722421,667868,99207,486133,478974,753731,133695,811917,512302,455837,464687,137921,476759,822363,395238,858495,318474,725976,451718,49263,91881,428080,110435,218470,227737,47156,808718,780074,296512,198364,261419,337581,362388,792106,893245,575727,778021,580321,977912,979610,375014,976367,465111,169138,339558,920257,390835,187451,724134,437318,60198,293326) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000932s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000975s ]