SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564003 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564003 [ RunTime:0.001710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (314877,171266,351904,210622,1010386,284741,43451,854930,124376,474403,304949,239179,762543,902658,557974,385778,723980,597809,820157,246941,419348,933765,667982,636767,359961,639010,388315,187370,955114,212142,863619,869580,630919,824347,19323,130386,350648,83122,130745,319677,15790,864413,885592,355427,60662,464875,525106,750743,857026,721186,662926,774353,105654,592278,86493,410500,287940,897854,928656,981089) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001802s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000471s ]