SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 276543 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 276543 [ RunTime:0.002794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002080,251411,271418,517456,959296,643575,102223,229583,402744,428993,333377,81392,1005323,1008300,136311,761235,838522,762716,870196,1000997,824734,5179,914100,938112,979619,952113,444001,305845,775121,755424,454450,433269,834799,807094,761843,895680,659836,761793,879620,92689,1025894,42183,943086,656453,1002014,212975,745206,324577,177349,683035,113899,223410,218749,150239,511233,847198,844702,706059,837991,974632) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 276543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 276543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]