SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 49176 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 49176 [ RunTime:0.003633s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (845013,835243,648613,105120,790639,698004,415377,237875,42009,738172,336771,684187,181008,609677,457411,425801,951913,664865,1032783,262851,324141,543844,211039,454121,232769,956470,1035200,217385,327857,147526,581955,103451,306364,133573,368381,844949,629277,349743,23117,661881,759564,421633,120289,689970,989581,636830,601520,175762,751773,1035979,896817,77418,768117,758004,1009975,783484,931843,69187,85878,879546) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 49176 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 49176 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000422s ]