SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201863 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201863 [ RunTime:0.003287s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (569580,397772,812384,516871,698689,519318,906924,845177,390512,844185,616204,621376,320178,466080,502105,736751,855392,150402,629578,525576,467866,1044815,1015328,686304,309945,543590,121808,465240,395050,702969,629487,1010443,754678,659713,110458,283296,464221,741757,335795,195437,597893,23798,345573,887397,763677,583289,1041344,483148,853185,507573,464028,677489,734783,498524,993170,707920,608885,139786,500161,626639) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001689s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201863 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201863 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000658s ]