SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003464s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 991291 LIMIT 1 [ RunTime:0.001660s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 991291 [ RunTime:0.005100s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (440620,772536,840441,892360,1043823,547115,229216,400275,110322,906556,628157,21303,982693,861232,708371,1016324,917019,641508,795248,134914,736655,521716,927564,833714,645382,1024498,762308,1015982,893983,826785,560166,383704,542585,462416,751997,19797,142659,960173,640544,843268,435780,479492,357702,1018452,435737,804875,32553,431153,541271,893377,1044091,427300,118397,56934,1029924,833588,411612,949903,452443,751988) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 991291 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003207s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 991291 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000727s ]