SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022844 LIMIT 1 [ RunTime:0.000490s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022844 [ RunTime:0.003495s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (548527,794016,393922,1025864,304985,385514,812366,158962,771433,999290,940278,980878,464914,48453,998222,768795,838807,952668,511510,40668,700519,193381,190153,53475,676202,116890,208616,936273,395436,667090,252920,470788,991611,200463,309036,116313,296690,508440,300441,727589,583069,242816,721419,215469,437811,124475,127642,536736,501242,11763,193995,139245,913120,440691,562731,474062,963926,968435,569262,556039) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022844 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022844 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]