SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023566 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023566 [ RunTime:0.001800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (198551,13233,854411,464253,968517,289280,145519,637009,946791,708416,1041224,533642,239171,789358,412444,484061,308232,457162,949867,853830,382495,814149,194427,966777,969402,540904,838618,724022,841108,335844,832633,183871,815773,689551,680852,720655,640091,913374,797127,887592,530145,138839,905743,980573,59928,842452,128165,598204,306492,473730,725075,165695,265329,206513,59084,15808,715428,611694,38266,341442) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023566 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023566 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]