SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503201 LIMIT 1 [ RunTime:0.004893s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503201 [ RunTime:0.003915s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (159641,788682,41722,101432,794171,134885,637197,841032,280576,724601,898171,1041224,602185,129984,436736,889472,698746,148557,42226,887126,322933,401436,125773,541411,806503,710851,431047,48524,86772,937382,810885,251984,63239,718981,839861,843567,379680,15086,353821,1044295,703035,276215,896109,489817,270619,1006364,270863,90069,559749,295842,440641,969268,246910,1000715,628645,107167,387884,969813,317423,193322) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001912s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001314s ]