SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517623 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517623 [ RunTime:0.001765s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (95521,80374,657827,23446,756750,166129,628097,511180,843516,455765,274507,68621,254130,270899,1009930,911868,185912,1038737,1438,371701,795998,801034,220381,369337,725152,4352,628890,347949,356412,160879,168115,313968,1033026,165073,306328,165631,426558,336426,112263,14091,133885,274529,290427,144130,95613,1028443,929338,454173,425149,666605,740923,527820,582722,129071,141610,854817,2142,722561,656350,62131) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517623 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517623 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]