SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418542 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418542 [ RunTime:0.004672s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (356677,69256,444903,188002,688174,429158,373689,525345,678949,162094,864835,557199,162530,335335,696851,727119,412162,768466,974205,383853,405196,699661,562448,349119,1046748,936804,701671,84941,278611,222283,254527,491056,880974,452839,490925,439615,989036,951547,41334,432346,929490,368033,832126,1037802,855796,166025,375017,876403,671644,696828,1046032,857895,911435,1039150,47502,865906,796892,421591,296960,612596) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418542 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418542 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000394s ]