SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427511 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427511 [ RunTime:0.001719s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (902913,807269,18044,699180,682173,125540,1032305,472811,713953,623074,106221,879980,669135,126965,933993,541366,599555,841511,130495,806581,700018,866624,259647,516079,291123,770912,867135,279457,154779,634094,172393,342897,44879,108020,310321,829103,429499,834267,206744,690511,745028,60878,718080,644488,377188,482507,89067,3967,344446,259141,280959,202688,963369,341506,266335,454968,48105,9177,924890,710014) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000657s ]