SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 396440 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 396440 [ RunTime:0.002220s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (249017,183661,939851,584980,593896,705415,418865,892561,82719,124544,662005,453443,826758,135874,2596,1018262,18362,619088,569972,287163,799470,262892,427576,224982,96446,90973,853671,110477,291679,207262,398306,1017854,700346,329881,511746,730237,610769,632514,1030286,355936,354291,4197,241681,19,138333,438774,507596,73679,843423,830908,620192,793794,359565,551788,379330,561251,648852,799195,973190,191206) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 396440 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 396440 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001332s ]