SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001391s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 525505 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 525505 [ RunTime:0.002909s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (799220,477581,921950,1737,670814,156114,126540,359485,581926,952363,921905,510868,1025979,101245,1010816,201864,89204,955218,231324,1044393,1575,25001,52517,974234,1002650,795702,931810,601610,334819,181363,678294,46521,968439,951098,310674,336742,414075,705447,737135,261652,169438,930027,67540,863126,310150,532312,181091,594583,68969,88633,95426,804985,527254,388069,61750,775785,552587,661840,501882,1005739) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 525505 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 525505 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.007613s ]