SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002518s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565213 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565213 [ RunTime:0.003687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (194998,427205,36327,303660,922547,731406,1019725,1012825,262187,541823,167152,361908,68400,1013446,990763,169926,233964,253882,790352,929297,412614,558150,598312,51991,836583,246582,8012,910457,100696,1008817,1026039,385432,517527,781658,140719,590376,937075,8162,111482,803470,76065,219304,127816,947903,625859,337428,614931,951965,207761,635998,1036884,445179,741084,349735,160607,1001910,639312,279989,801525,331016) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.017371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002182s ]