SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5372 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5372 [ RunTime:0.001757s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (75965,828044,487652,525935,425563,379300,8977,571524,958317,842590,752026,659973,808060,959518,344237,821810,1015227,629717,647072,275168,1036986,383515,899081,170719,549618,103847,555501,120684,849401,372451,125318,643171,152202,466797,298918,1000445,472933,915499,686040,332899,68087,430146,478677,70400,114221,436456,901941,935836,815961,981166,247944,633725,457779,355095,394103,385609,632041,31710,275661,947059) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5372 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5372 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]