SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513398 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513398 [ RunTime:0.001914s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1006150,425982,803469,100196,468064,289924,526495,787649,180299,89715,578267,919096,887890,364702,382396,723129,946457,1005216,85225,723826,644321,837628,638742,896731,185427,66351,885501,113646,566014,940710,344520,487306,513200,731266,49558,255398,4963,654064,781127,946030,978398,577370,771355,984098,1022666,948910,398055,377987,767025,474277,490525,777717,658317,686799,833599,204604,646593,65119,922405,877882) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000404s ]