SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 204589 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 204589 [ RunTime:0.001636s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (816733,641025,664861,21663,469537,48472,686225,605976,982558,84667,459921,191383,261765,713791,495054,711981,282554,656929,1025461,741629,599965,460360,334678,24287,653314,300153,363714,477315,70488,492953,481701,204668,99425,602632,90765,44314,764901,185144,659573,1107,809762,859544,1032516,1033251,519578,943054,447089,305837,271027,998620,379855,935235,575246,516854,253826,575344,529904,68529,391864,640549) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 204589 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 204589 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]