SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042201 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042201 [ RunTime:0.001719s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (265589,688693,887813,69921,667743,180818,651691,901770,157491,918995,873706,770280,1017805,659872,418376,619320,321098,627811,251044,444579,188196,606497,728685,857211,631218,74463,898520,59531,353207,670196,577374,653336,573861,870822,80032,114534,906558,124282,776836,572795,385689,1029174,1019315,497132,102720,58099,851805,18318,430822,491727,599298,764873,459620,100338,165203,46359,698261,426582,193010,946633) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]