SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545410 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545410 [ RunTime:0.001863s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (910997,272689,507109,340049,749280,821514,874110,156465,302058,383226,804369,1026362,1027992,131555,990134,241148,126683,616492,515878,92777,938622,215071,302794,864429,1045139,942757,64230,1027836,726386,988078,594474,245326,262075,887304,71554,997902,835049,733555,619733,699499,595245,241862,417486,436935,980482,100690,830647,1003592,89236,319642,375852,959145,904535,250436,855899,499796,548544,1032453,27813,601028) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000948s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]