SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 292809 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 292809 [ RunTime:0.001623s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (739292,402631,237102,498231,734900,445945,670043,616687,211602,715724,160910,757343,402987,802080,424132,695985,368749,94491,258453,241540,364034,141663,508702,327698,563616,868078,948639,819397,251647,220146,975002,252252,190725,99052,765553,306970,866528,367281,1014524,600313,843502,624573,702296,777345,942,865145,134620,374790,622549,208552,730120,745537,1016260,894275,842861,984688,121638,755231,781462,756626) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 292809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 292809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]