SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 588098 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 588098 [ RunTime:0.003624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (100691,865902,397172,715179,297160,762497,563550,466533,810674,48681,499125,827572,863118,117275,279239,374956,334070,265987,75033,360244,610722,896885,356544,212147,109685,737056,466320,126999,1030452,971955,390928,618817,460535,230654,707877,504552,680264,1030780,568580,829301,175656,315860,766770,980672,96465,455486,176813,881015,695728,764478,451741,529357,177246,122369,751154,304684,739413,622019,716670,842083) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 588098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 588098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]