SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503894 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503894 [ RunTime:0.003811s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1023416,174613,241587,768875,342830,922063,133965,298742,78372,488701,621771,389934,951986,954689,195916,395165,560501,45609,1039721,242082,968451,233145,983516,682112,761545,179235,110390,447151,43530,933146,50107,585530,281547,659418,575779,238150,77742,973843,300841,23364,929906,692756,816494,301939,148727,617915,402045,379726,53580,279836,450651,538282,218908,102111,336698,492710,58464,762843,402611,621836) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503894 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503894 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002023s ]