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` = 331425 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331425 [ RunTime:0.001704s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005382,697172,282041,918620,912645,489058,1048197,191592,182256,1034188,4104,750914,315630,123783,75472,867114,725749,670245,839204,672937,411890,335460,105201,945516,865773,939101,907070,1019974,433491,1045896,570702,538820,305183,420811,485397,247741,408961,407798,299627,411726,675247,599202,995710,920452,292399,795950,458224,6159,360963,971284,439360,67020,503128,675586,14766,966410,426654,26747,594388,127367) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331425 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331425 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]