SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014880 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014880 [ RunTime:0.004765s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (294434,485905,989652,11832,214597,928513,627692,91509,621837,49102,48991,806668,73678,371617,471340,361268,569942,185475,79172,110632,804494,417984,806156,430173,323876,220811,726399,788883,364642,176667,746969,278793,638704,1017922,644245,1008355,449848,38790,971481,200216,635448,521444,202333,225947,310964,183298,318026,250778,480554,155102,119242,385488,35384,200516,155260,302416,134529,162689,1022570,568189) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014880 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014880 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]