SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 219800 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 219800 [ RunTime:0.001830s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (152974,821441,250313,798611,227381,656100,663640,824073,878735,848995,293376,25283,366281,30420,129307,842997,865580,391215,336085,81275,917581,357966,451590,150126,167421,717587,945693,734538,88147,858817,701741,1028402,625876,803845,755390,231450,319205,926558,997369,963823,263496,646886,399448,210215,65750,565677,618465,676972,818527,920294,600170,720207,273625,842773,926490,156977,989949,63548,468491,112581) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 219800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 219800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000723s ]