SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109716 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109716 [ RunTime:0.001955s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (514102,354672,21724,455500,980274,823813,388413,489953,758439,141348,450695,335456,916411,937773,939569,298374,444395,650140,387629,611013,11720,644832,681846,385905,39593,837363,239951,267191,313902,518761,427142,771752,898347,950332,845180,307144,629523,495158,405950,201213,364220,445051,319373,694945,891647,489608,881945,396809,856774,332307,530511,887391,713187,20188,220571,234222,293716,856148,939904,836114) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109716 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109716 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000363s ]