SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537196 LIMIT 1 [ RunTime:0.000833s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537196 [ RunTime:0.001878s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (486564,43869,806870,652435,731765,344332,344282,687116,812574,271722,585890,92992,808186,302154,541053,666736,984450,5295,729487,989545,406826,890375,233915,803025,572027,944511,937707,404489,151114,194963,769694,717989,756330,942709,990391,686496,503342,815655,641766,269647,697582,840159,592378,475743,757938,645665,204117,409439,578070,649486,915073,921887,160561,941799,498543,26520,428094,420748,1040670,2070) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537196 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537196 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]