SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102182 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102182 [ RunTime:0.001532s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (545880,684487,638942,419530,56992,917638,191069,13251,713127,985090,707333,544953,1025229,612952,168537,392371,65674,240435,260330,920800,172260,390744,687920,577033,1010586,161951,704778,186425,646367,982628,740214,561542,709997,942842,843168,612322,124466,950940,738844,80175,336782,174904,751102,1001438,461424,303627,683686,353757,221426,293017,559316,122321,1025919,963656,69855,202741,1041715,50950,970910,5666) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102182 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000749s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102182 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]