SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 289098 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 289098 [ RunTime:0.001880s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (523971,122222,1013138,639918,1032856,866905,517963,632662,176808,393578,247726,235154,911071,68375,542336,516768,1039255,429614,708684,225804,691989,705083,982623,327774,758746,411794,709831,1033455,930402,726040,66996,410403,88175,755323,415617,22790,579105,913871,638733,841067,353738,162158,281628,366835,34983,241542,321504,226001,894617,12615,386499,1018043,937802,931739,837821,437144,271167,4258,182165,329651) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 289098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 289098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000403s ]