SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001752s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507413 LIMIT 1 [ RunTime:0.000932s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507413 [ RunTime:0.004211s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (637837,474372,891714,1043163,357015,225914,950439,404923,356691,333776,270747,79960,554660,562469,802380,1030949,961347,315578,42928,470415,153894,250554,258762,32818,850479,959911,873300,259271,840441,79527,284194,177343,215993,710190,26055,439311,64957,213520,928954,654430,942910,328056,21703,1013213,552516,411610,614135,601213,627787,291215,84492,870228,473702,164224,963564,729260,3285,890778,846464,148118) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000676s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]